Name  co2_per_capita
122                     Qatar       46.930194
79                     Kuwait       29.160208
154      United Arab Emirates       29.052226
88                 Luxembourg       27.352097
9                     Bahrain       19.223833
..                        ...             ...
27                       Chad        0.062167
50                   Ethiopia        0.057042
26   Central African Republic        0.055764
125                    Rwanda        0.055569
21                    Burundi        0.029194

[164 rows x 2 columns]

PIVOT TABLE: Top 10 CO2 Emitting Countries (1950-2023)
================================================================================
Country                   Avg MtCO2       Avg Population     Avg GDP        
--------------------------------------------------------------------------------
United States             4,623.2         247.2M             $9.2T          
China                     3,540.2         1.04B              $6.1T          
Russia                    1,550.5         136.4M             $1.8T          
Germany                   894.6           78.5M              $2.1T          
Japan                     873.4           115.5M             $2.8T          
India                     792.7           832.6M             $2.6T          
United Kingdom            550.2           57.8M              $1.5T          
Ukraine                   417.1           48.6M              $402.7B        
Canada                    414.4           26.4M              $826.6B        
France                    379.9           55.4M              $1.5T